Performance Analysis Of Scalable Sql And Nosql Databases : A Quantitative Approach
نویسندگان
چکیده
PERFORMANCE ANALYSIS OF SCALABLE SQL AND NOSQL DATABASES: AQUANTITATIVE APPROACHby HARISH BALASUBRAMANIANMay 2014Advisor: Dr.Weisong ShiMajor: Computer ScienceDegree: Master of Science Benchmarking is a common method in evaluating and choosing a NoSQL database.There are already lots of benchmarking reports available in internet and research papers. Most ofthe benchmark reports measure the database performance only by overall throughput and latency.This is an adequate performance analysis but need not to be the end. We define some newperspectives which also need to be considered during NoSQL performance analysis. We havedemonstrated this approach by benchmarking HBase, MongoDB and sharded MySQL usingYCSB. Based on the results we observe that NoSQL databases do not consider the capability ofthe data nodes while assigning data to it. And these databases’ performance is seriously affectedby the bottleneck nodes and the databases are not attempting to resolve this bottleneck situationautomatically.
منابع مشابه
Comparative Study of the New Generation, Agile, Scalable, High Performance NOSQL Databases
Relational database is widely used in most of the application to store and retrieve data. They work best when they handle a limited set of data. Handling real time huge volume of data like internet was inefficient in relation database systems. To overcome this problem the "NO-SQL" or "Not Only SQL" Database came into existence. This paper discusses about problems with relation databases and how...
متن کاملAn Effective Scalable SQL Engine for NoSQL Databases
NoSQL databases were initially devised to support a few concrete extreme scale applications. Since the specificity and scale of the target systems justified the investment of manually crafting application code their limited query and indexing capabilities were not a major impediment. However, with a considerable number of mature alternatives now available there is an increasing willingness to u...
متن کاملNewSQL: Towards Next-Generation Scalable RDBMS for Online Transaction Processing (OLTP) for Big Data Management
One of the key advances in resolving the “big-data” problem has been the emergence of an alternative database technology. Today, classic RDBMS are complemented by a rich set of alternative Data Management Systems (DMS) specially designed to handle the volume, variety, velocity and variability of Big Data collections; these DMS include NoSQL, NewSQL and Search-based systems. NewSQL is a class of...
متن کاملAn Approach of SQL to JSON Transformation For Handling Database Operations
Nowadays NOSQL databases are becoming more popular. Companies like Google, Facebook, and Amazon has created their own NOSQL databases based on their requirements. Different types of querying approaches are followed by different NOSQL databases, whereas traditional databases like MySQL, ORACLE, etc. follows SQL for querying. Most of the companies are shifting from traditional databases to NOSQL ...
متن کاملScalable Persisting and Querying of Streaming Data by Utilizing a NoSQL Data Store
Relational databases provide technology for scalable queries over persistent data. In many application scenarios a problem with conventional relational database technology is that loading large data logs produced at high rates into a database management system (DBMS) may not be fast enough, because of the high cost of indexing and converting data during loading. As an alternative a modern index...
متن کامل